SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511417 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511417 [ RunTime:0.002361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810071,13946,448167,408074,606324,90357,664083,1028101,1017033,883501,913945,1033914,1043037,866507,765398,632412,404202,1037249,33,830831,643497,570852,287322,1011360,180293,765870,375300,417426,178296,408488,665362,452920,195829,1040778,948254,491783,294327,770972,368847,980428,619869,979929,546417,82550,479733,708733,628362,223676,433206,790518,1000361,792452,584600,90712,588809,702315,426176,15472,755209,747829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]