SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42281 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42281 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300239,694681,887493,3414,888212,81146,920238,783282,625143,145189,511160,802301,500544,337670,637028,1007860,890091,256440,997870,867663,260743,340746,10583,737203,373943,788191,684751,170481,685271,28231,381628,895564,693228,299449,963335,942808,820256,286495,560301,370276,136222,555453,484762,278725,452281,464613,870838,806504,567460,166938,338724,662267,540417,378633,378539,294562,654863,42471,488480,259198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]