SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 582596 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 582596 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99336,29397,322734,244474,442009,398371,254037,774696,406660,47082,25592,22033,526558,481742,423661,952155,1024245,584113,897505,631842,389772,74493,872625,733244,435406,866813,527996,981743,250215,859239,1022394,278123,697457,57020,880753,781189,797070,342449,640975,325972,1009264,239874,899096,491346,437450,33496,905664,1011290,360163,246245,814662,733155,315248,314504,822954,667436,126079,849823,558397,451089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 582596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 582596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]