SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489710 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489710 [ RunTime:0.003539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (968623,894710,99865,712241,588171,988614,259037,127548,468916,481447,802806,41604,197308,44143,428867,21654,311902,94836,779558,927939,251476,236347,449467,912134,494080,117592,780356,22870,645315,571845,377164,674239,229589,775197,862386,595522,68100,243433,732475,127943,999662,265273,691724,161920,881898,972491,879594,26726,363583,765098,588752,980960,854094,138206,745276,822625,412403,471155,1022376,766981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]