SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432678 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432678 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024760,507935,49468,481233,456778,927482,944382,315920,281131,383998,931646,636051,878095,935933,889783,143412,87604,446656,248557,741400,544361,930914,103622,957284,462946,842619,249732,231733,18408,188754,185038,281406,962986,907161,987222,27923,836332,285412,420117,139972,584240,380162,645913,218925,777344,513228,890147,478090,745047,408353,427214,533304,253744,90690,486557,433898,850805,1016069,67873,1047828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]