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` = 1001970 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001970 [ RunTime:0.001992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (823253,537644,1003751,386052,330089,645665,471947,1045911,1024043,1030975,201212,512334,11251,278268,423129,680119,22818,611317,173618,39828,525913,922767,35428,764591,845979,339022,233968,648676,993630,952892,26628,827037,693087,998254,804993,332000,863310,819623,365980,584367,535717,63185,848474,602478,622809,604364,888383,295401,254756,349627,579566,108793,693557,431505,736081,136344,151507,889837,854132,350947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]