SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584286 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584286 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928136,36840,581243,706912,80108,379042,442146,901846,76992,87459,276192,665438,481332,190141,292035,264092,177636,583241,326713,17591,652833,675779,433733,731183,149939,325670,1017533,433636,1041752,399767,889812,954727,269751,822833,521192,22265,389337,207483,12676,632815,789175,353356,446052,830835,497464,35920,159857,905072,604053,832304,777800,805093,78233,596485,838845,745941,536757,157095,417717,522445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584286 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584286 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]