SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557906 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557906 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (903180,777527,955900,410119,863619,986997,876068,152598,161482,160122,772290,824804,208176,791509,569838,666204,162686,560711,783702,1035308,698227,654973,989872,44093,66316,550589,803178,678311,275384,567170,209339,210321,833997,192839,393852,744906,242442,983749,978555,36448,190196,710735,389775,376187,453636,1027198,305538,504985,18181,251638,59457,52432,773019,78964,41555,146444,484324,743249,227991,476021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]