SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510318 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510318 [ RunTime:0.001463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (857773,555313,418704,707279,134371,836668,839152,9667,420233,236338,168911,681389,604745,800437,755311,892869,207230,312745,579577,726593,531058,182945,423880,380246,844840,563116,886030,185167,1012220,136156,304671,790466,501966,242440,663449,1046505,71528,343870,362026,229314,271139,1038334,8754,472378,1001729,701009,719044,720023,759317,373738,733169,300992,492317,673861,618245,832529,713960,939953,899136,389822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]