SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420022 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420022 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (571247,448535,353739,242936,779393,1018181,953055,88110,801183,47385,309250,872705,72343,554950,38875,758143,506519,1026690,838417,665525,323129,61214,721907,399537,1007117,480779,837175,460820,518056,54604,772936,988706,557268,579330,449608,142907,386771,29655,827755,862275,833675,178891,271327,655558,813713,743971,268322,840118,669615,793351,187003,413233,962173,1021059,406215,677464,323006,568383,299832,570488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001886s ]