SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002697s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458010 LIMIT 1 [ RunTime:0.004762s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458010 [ RunTime:0.006954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888910,160641,192977,115335,972049,950705,623070,330455,118479,247891,621671,296951,196391,699247,171728,463539,143995,617580,752229,206391,439973,403272,717706,281488,561548,30229,684171,604827,753498,77070,322375,533404,822804,384402,418071,567401,171871,132078,1044502,991300,920526,311154,331304,874138,362868,911183,282453,950863,409957,691562,465484,845548,155605,401596,614360,123298,940308,569630,403949,560462) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002846s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001766s ]