SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520705 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520705 [ RunTime:0.004243s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449276,735450,394659,138113,775942,283863,707315,497798,38242,829505,503431,846250,110710,981031,644051,992962,272573,691808,19695,469104,490669,380977,974443,210912,723121,468625,482107,904499,594437,414763,6334,601322,947257,854048,894003,253279,367380,738752,809643,363334,101939,158663,377853,229228,713230,815780,625272,385495,707922,141925,740375,374004,1038180,101381,76175,1024909,580731,348879,646303,807841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520705 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520705 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002339s ]