SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002036s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426510 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426510 [ RunTime:0.002629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342026,87500,929615,619080,337994,9919,29915,820561,771939,415466,95945,73319,51553,16451,284298,862168,122963,5214,857929,696280,6206,167165,1009733,415013,513329,772531,58142,131084,997546,792363,226636,758483,821406,635515,673445,915216,674401,165004,569615,635048,818190,247196,495415,402476,661820,479686,877027,584121,476988,607824,237586,1034837,938190,990912,404681,1026192,411985,585311,151347,943339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]