SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400484 LIMIT 1 [ RunTime:0.000659s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400484 [ RunTime:0.003023s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (828597,259032,393944,1011039,708490,929059,620025,73914,614474,26396,43876,739088,698315,629298,867808,557249,151400,428771,359675,588925,7013,828579,321907,854038,754629,523489,701345,278820,1028749,596668,11891,161455,255007,315161,989826,693955,13543,548641,539804,334425,296725,562487,773536,849596,145185,630558,987052,156041,888432,343390,172947,640428,831628,633045,754445,180292,114551,513595,913599,424832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400484 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400484 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]