SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310046 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310046 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007775,965441,463104,105891,992026,972541,393453,472501,298513,71559,53164,246053,524107,696026,976865,270742,261599,537108,479285,604195,483231,494566,400340,594264,445554,946833,1020415,749089,799632,954964,738545,411313,492752,229287,789095,349263,859917,219827,945735,778535,92494,883142,833745,103228,915496,757334,988870,992544,365803,439179,643030,705927,537972,495170,1044340,350231,835452,941693,296705,608311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]