SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002940s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101631 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101631 [ RunTime:0.003837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510743,986273,890178,152786,564098,157941,687023,1008087,818138,691607,619116,849688,356466,770058,212027,1004490,20428,320435,73526,982513,267906,305387,787662,713740,394967,347015,321137,731309,697868,827602,798863,802200,884113,226165,662214,935282,758449,192783,218014,961125,638,627536,775014,858213,26831,385745,376696,711895,561786,793,195489,183020,848816,469309,527418,85143,307049,888957,9073,501274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]