SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465781 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465781 [ RunTime:0.002052s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724369,405089,588012,368155,243330,863446,583424,817867,239487,858694,111973,460757,460712,488353,276654,233458,845715,701291,49870,681650,331017,53577,768402,413681,563629,826170,494662,982201,444203,432923,880709,458119,1040617,220709,341547,759816,1001202,882084,414870,490783,983633,697732,863423,70273,381221,742485,209851,696218,242472,55483,670183,68036,22904,822007,933493,388200,1009148,241934,679451,72744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]