SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 620119 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 620119 [ RunTime:0.002596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188105,415579,86326,60635,774676,45396,849180,302123,741488,752178,110580,1046575,160420,607174,314872,449087,1021483,850913,525662,189478,368722,290019,299481,332049,972119,628986,755810,635048,173418,32830,678368,736744,1026596,920085,893007,832480,945814,9166,1002201,341427,249862,344713,414888,851876,626075,436132,1041465,954237,235588,887779,528005,553960,747491,1023299,577555,193886,473386,517182,380078,221107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 620119 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 620119 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]