SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53890 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53890 [ RunTime:0.003760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417233,481357,281349,933273,525366,742723,958723,648656,557417,1030042,817271,985186,176786,279884,170734,118451,552392,639827,801822,18606,581119,55485,964258,201365,311288,686395,843967,18329,15630,440668,624446,684800,531065,461903,195587,547232,584280,249956,907541,483947,894195,304442,32359,244289,941551,325049,417683,327404,1004270,128751,60623,60775,302608,318158,212705,364320,657719,590215,501133,883566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]