SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002771s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448836 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448836 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008227,752914,1023750,531035,502664,1002021,551687,194932,492318,26009,356581,217196,345062,864606,895526,503218,57966,866965,584955,1027519,792257,276768,722159,781246,463946,758933,38246,487895,602920,593018,212012,72559,1046630,832947,685723,689092,887865,455052,184301,201257,216861,308974,268462,40052,376087,362650,318561,864848,851489,465370,380158,478267,589772,932512,557506,226717,306613,637782,46606,475513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]