SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502616 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502616 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (718754,134282,528980,307323,122332,958749,462848,801493,511810,62718,913253,370578,190299,29416,821982,950124,1004423,188607,829236,212720,720058,414035,411698,801253,740158,787059,891399,605408,1041755,927130,438079,371603,988669,201951,464934,180433,845903,707117,336095,420233,465852,275625,161293,271099,931605,1021995,425612,774354,799775,191578,30159,384455,254218,555088,758333,852197,709568,707986,981117,747187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]