SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527612 LIMIT 1 [ RunTime:0.001297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527612 [ RunTime:0.002228s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313558,315821,926282,549848,317187,670206,1017743,344636,534425,281669,411599,738984,438482,902975,348928,854879,488311,347260,481451,408813,638512,312829,123690,865653,782966,245792,1031091,895204,406313,146715,207382,561092,655353,632262,805667,185078,278245,301907,569065,341415,384796,990776,83813,78653,205731,472230,43919,136766,713930,293239,846668,95129,579882,548641,526571,884284,758680,18883,813749,48826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001780s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]