SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354821 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354821 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741373,951668,1012394,179497,1036789,415307,35777,142263,780842,513022,591635,151419,161339,865810,940784,847090,147530,566200,660725,849138,794674,593186,805601,863449,854104,692267,900680,806232,970459,630078,101455,1002300,95946,996499,578028,918945,239488,182491,373695,791918,551628,913400,126312,503855,258539,447703,928471,925135,275174,987296,482953,373752,289731,221621,521865,110337,926288,877675,715801,997540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]