SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501683 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501683 [ RunTime:0.002470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943382,859248,513214,893816,647626,773900,201335,139446,753775,976287,909670,253627,104333,632388,175371,432245,249686,313155,200517,719235,77845,662349,496173,382756,488031,991506,25163,730289,194519,494158,192186,624858,28920,523285,508482,968085,204221,396044,776303,111189,649860,418564,571191,522948,1025821,87190,485405,1047642,54752,540524,380899,615554,87744,885461,340103,955150,186077,658383,3409,654151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]