SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001552s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545300 LIMIT 1 [ RunTime:0.001437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545300 [ RunTime:0.004616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473673,988424,908530,737507,440819,64454,668369,643143,208602,133536,73418,897966,1007347,1031106,542158,914676,293293,176519,565558,152998,595371,288890,147824,1028044,113483,665980,352116,127290,291199,952069,450837,602763,694191,512404,908874,459760,231776,133324,409442,929295,341705,636243,728469,224358,994141,426525,474757,240295,875369,48381,351094,935889,124091,821508,925660,590217,649388,70973,339540,992691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001709s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000751s ]