SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390445 LIMIT 1 [ RunTime:0.000883s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390445 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484970,499252,901731,401669,239756,613171,323823,111481,686840,513849,20309,773523,367690,130366,1045582,694626,668200,395571,243133,274618,94501,676704,3234,385270,636158,649333,494309,26407,506471,1046985,540796,10324,968972,820654,547353,965363,583601,976305,865119,217015,961983,1031555,949087,222570,828428,79788,282653,214951,446362,767580,422519,542148,652696,266810,374834,910393,433623,99418,542188,266040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]