SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565458 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565458 [ RunTime:0.001202s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557901,351999,553570,816508,16421,251829,704575,702023,383202,974353,890135,225041,939425,588084,266925,138165,129325,554039,666792,845980,330401,546737,335423,1035686,475404,809546,839135,960143,825764,803693,841446,740617,698600,741829,349258,273080,786162,1040172,293772,1045966,982859,644151,1031537,623754,568671,378389,747260,73400,380164,175483,72803,484194,671807,572610,531958,552262,195186,373213,247350,979426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]