SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002616s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503088 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503088 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612779,141348,354025,834705,230218,460911,920641,370714,365909,409040,97345,214989,288428,881199,138546,332305,730336,408453,975842,388858,681129,297238,403150,272465,303992,878146,11970,800006,168215,150956,198304,701889,567450,182282,424213,694187,702493,408775,537103,136129,112649,290752,504127,633981,325845,821578,1048181,122952,504019,155138,955478,714635,253262,63941,178650,762017,475891,199446,54292,123856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000881s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001960s ]