SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504264 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504264 [ RunTime:0.001953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606782,935351,131266,780408,534474,308942,644292,886402,438716,764104,849286,125707,892266,822406,812988,112028,695276,390802,835221,297189,887615,915419,914516,859611,128597,867569,145736,508384,291521,299953,125626,720928,545362,272521,62785,878376,426611,534004,386431,831561,565781,73942,858337,66539,984279,990645,975269,530560,244523,934865,890397,632095,189296,502420,692429,476642,563967,13301,726410,240850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504264 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504264 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]