SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5406 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5406 [ RunTime:0.003075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89124,928450,524760,894839,1004663,265997,64108,576462,428846,715267,283339,529580,900814,226216,678111,106373,21162,229477,590996,515399,997729,891405,738383,880754,106912,981247,952139,603280,16339,914348,997234,384481,1001648,1013438,151507,438852,698332,382363,205851,1027596,281719,530790,34468,163588,641933,311232,887259,509335,196517,495060,277288,452423,66485,613124,817621,390071,374259,899440,1002947,484822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]