SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345198 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345198 [ RunTime:0.001512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378947,578763,639559,241797,374065,205778,153550,1019464,495936,840719,63877,767468,952945,752558,339763,114919,606852,897542,103478,700017,127128,367783,176683,776509,240878,172743,267637,902934,606620,694152,604738,773698,272009,586428,136973,659683,1008448,986090,96911,913340,92889,561241,755284,679953,33722,385877,309213,788999,793427,912496,95428,71577,1013062,786995,384879,634732,366341,176804,686016,805434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]