SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291754 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291754 [ RunTime:0.002221s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812196,560914,740188,295147,493185,163242,721212,86698,618084,381036,444563,724715,315434,4497,844640,612911,276542,44558,276831,481640,332306,760416,656674,900788,517861,35640,1014032,960938,649782,17578,385685,1035400,208033,258544,61948,771369,82097,190635,754140,287141,163486,1039656,616694,292885,359169,315613,740448,341230,795313,96211,664800,975921,30770,351159,640033,858181,599642,301539,483817,300182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291754 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291754 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]