SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394688 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394688 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108624,358406,143351,628087,127292,90795,197998,441205,9088,916434,822691,10400,175000,36216,853456,640002,12439,745081,617480,391508,1013729,1011864,639372,840249,246079,438057,465706,32005,271324,241250,586201,119720,628654,456219,374620,272724,536825,647061,676955,481009,856797,913616,272600,640907,86365,194999,462819,190970,902464,72604,562139,853060,174524,419285,87917,884031,178144,185285,720124,174907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]