SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459714 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459714 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449692,186870,113769,167053,172862,179768,280299,453695,402835,719348,519138,114206,581722,829763,212309,42199,210358,89819,1046816,1010424,294780,317691,225177,600821,955433,495114,649700,739578,305666,485261,557134,929153,462381,562795,81652,726294,666788,827141,495158,949749,3511,237232,162883,272492,835008,228441,1022997,168434,748823,875360,172580,559904,689155,355850,48622,808379,138201,640882,684728,398976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]