SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429843 LIMIT 1 [ RunTime:0.000565s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429843 [ RunTime:0.001531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (705791,194642,107895,569236,169358,36617,484479,862649,377955,94193,157568,958705,109840,658568,279040,28271,388293,829338,384134,963480,197645,199400,177713,1046070,420037,790918,999833,113867,347684,883655,286087,545454,781861,24579,760593,408265,273869,153020,964436,441524,133842,602477,9127,281796,14719,150073,510691,161301,789618,649398,208098,919800,469245,383148,246157,743243,930095,542497,402357,786525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]