SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 208653 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 208653 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800209,520464,921737,1028711,55800,114115,132277,742170,1031711,911088,684628,43362,508587,936438,879461,147188,633215,376198,489147,748185,831298,331551,297313,87278,1043900,223379,174253,22325,803910,722906,819157,39905,193031,529029,414865,720363,970273,344015,9864,301609,705850,260141,1035595,353146,422265,608373,734668,271471,111121,993594,724930,520017,758092,225460,706440,101386,632128,633331,956341,451054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 208653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 208653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000708s ]