SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400451 LIMIT 1 [ RunTime:0.002598s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400451 [ RunTime:0.003231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (590340,687537,213799,889348,370438,248537,691961,850296,751526,742672,422315,11108,390824,129215,1015953,199572,104711,659930,839701,50235,617671,56873,822005,95333,906542,622255,586320,705195,47308,804939,675714,570711,143556,670322,1016216,1004935,789295,229808,299732,940823,640586,868901,952801,773103,352676,714158,133983,172581,576435,1005912,301093,394393,664882,1033684,920415,983222,506760,842784,1002561,357024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]