SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002717s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553411 LIMIT 1 [ RunTime:0.000515s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553411 [ RunTime:0.003729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431582,112521,671143,126048,38630,503617,169495,3378,1003159,579993,817560,830873,835379,369503,142522,835777,82493,465066,741175,498835,177447,169,904018,1038866,329830,860022,121687,434817,180335,952921,306179,993786,201481,444802,188789,1030815,580468,738663,1012365,264589,798713,209253,91727,664220,262421,272873,362999,456808,1039381,521948,642089,171909,1002508,492088,221674,581379,312810,96714,812265,443019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]