SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596478 LIMIT 1 [ RunTime:0.000494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596478 [ RunTime:0.002355s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (921001,868304,268731,557501,35099,55849,910212,958211,98115,58168,317595,303547,905312,200463,817632,201535,316516,514110,1018793,325502,154285,281329,280194,509395,457574,607990,103322,343004,658566,616696,741685,1018188,107306,756022,664880,847041,448441,174005,12417,104006,297116,978378,429156,572944,84582,187975,336777,604994,139677,397256,954931,869620,661725,621813,695071,340870,262340,683760,1033828,400260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002317s ]