SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493300 LIMIT 1 [ RunTime:0.003005s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493300 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487321,201967,545513,353358,246640,971757,199215,481990,907862,354720,990714,136023,604107,205643,224723,93770,227611,71768,155183,139608,895569,440248,155295,240343,947387,136544,1011137,1002276,854189,845043,3828,981728,1003797,13760,465037,1045499,975829,460875,851476,1020449,891378,815641,614295,92577,554928,69251,739502,856478,1034261,637078,108108,228366,758890,293320,404361,92231,258090,257179,102093,896865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]