SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681014 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681014 [ RunTime:0.002663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684836,842211,633282,79258,288334,967951,842179,612047,646709,568199,963255,577968,625882,646424,824429,978712,763523,118832,687870,641780,508392,365937,233701,983675,438921,987272,167409,281013,359175,1010786,955034,793210,667272,855617,998121,308559,850704,866941,791374,398997,102551,18649,805238,927358,1031124,828646,118424,48789,360938,79365,622448,534316,481479,80210,601236,86591,339015,965194,463257,108069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]