SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043280 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043280 [ RunTime:0.003490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972847,429020,398932,335153,786309,289994,219849,204707,230611,374317,885393,491268,914405,547992,314903,685205,948021,610280,938452,92951,207716,478010,8797,600273,650129,165094,58056,442589,903875,1014171,160647,939120,638115,978998,74022,878887,14235,701388,495335,1047643,623872,904077,827329,998370,379660,45841,10786,497419,942222,850694,706005,326426,159908,594492,95372,359659,303062,582343,94472,616870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001711s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]