SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 592294 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 592294 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (870081,1039723,527013,639454,936845,391181,96534,807053,7718,1048456,568628,975957,820001,993734,422339,839509,299629,1013645,491810,662224,395161,1046550,673026,307024,903895,591111,1006806,939698,412701,876828,892715,146028,864489,345669,934383,710856,993150,918311,18048,677473,979302,982620,124037,639541,145117,182592,736386,501787,494527,908275,252242,841505,24083,888898,860082,409537,215545,435157,804592,328949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 592294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 592294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]