SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458156 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458156 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142040,724001,384858,392869,392254,370612,24942,704151,473676,193943,97969,679905,715032,1007138,71105,850571,659984,713032,4265,695185,145114,44682,362686,927494,49915,412149,56729,282956,707219,713891,756400,341635,910945,540297,531049,909054,890928,904783,672727,417588,256321,315949,345933,274356,894012,925286,380156,662632,448520,317990,621663,150156,433987,222885,68316,805417,210226,60386,246308,353455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458156 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458156 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]