SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291878 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291878 [ RunTime:0.002210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503018,341975,468847,855341,486945,1043261,204007,270241,210635,150889,307839,70998,844312,356894,1019086,458660,100892,734737,890049,671191,445566,388103,954015,846525,941814,727472,163949,810876,92024,109273,621896,594944,358612,1000279,33231,593139,669481,135164,788712,603628,610787,217544,209511,673686,65871,229755,222271,498141,836416,419428,191523,20418,186782,657222,34645,868442,86033,57553,763904,619069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291878 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291878 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]