SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504904 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504904 [ RunTime:0.004352s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (633684,498448,798301,417859,344799,688364,908694,447178,315161,180307,309516,524125,860580,408054,987975,888205,909842,611704,857355,267371,803104,249927,213341,677758,751377,920920,321534,388354,805510,115219,721589,926994,264838,348852,598963,106442,896370,861895,563329,513911,295905,266526,672422,892358,200508,177158,284969,988546,471912,613350,561593,249296,428563,708827,247590,104734,609098,1045895,109064,285642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]