SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428409 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428409 [ RunTime:0.003561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341493,494006,1012320,349345,473523,626321,798403,161965,264207,972814,944260,334747,313053,670864,852106,439121,839185,759779,9322,110948,174134,669278,688070,252583,810362,189343,495494,288374,355742,568208,167218,711331,488716,158709,338983,29375,714777,234269,1024040,870008,543037,801374,707741,281002,579546,317409,112107,323229,1027601,1026626,50100,851474,897958,87468,21800,478194,640658,679120,275598,898911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000945s ]