SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016667 LIMIT 1 [ RunTime:0.001494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016667 [ RunTime:0.006077s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802861,273238,274877,820103,428546,963690,793110,390712,524252,131419,72255,1046376,74694,247676,185577,618700,125699,23933,808494,335193,189408,689677,232751,57365,365188,622359,250837,1021430,466107,359943,234549,540637,1023746,502047,926655,80574,1011555,1040863,208147,1008157,821595,608277,1027651,413140,861951,378195,53646,771577,546207,74811,408787,183928,136138,778441,263909,219512,417431,743035,816379,904696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016667 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003769s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016667 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001033s ]