SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001718s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525480 LIMIT 1 [ RunTime:0.000488s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525480 [ RunTime:0.002477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261116,223973,128140,123776,318148,981066,888766,693803,363267,984593,646329,880559,80445,223402,139243,272738,67146,853235,630688,112362,404284,10007,479499,991566,94408,347530,199560,540562,236276,312408,287823,160590,449570,216266,1023141,512181,43315,506076,556888,5446,520949,922233,553337,841040,500568,42240,290572,981689,633655,904131,947846,885015,1036467,769183,962765,374865,704132,330202,626140,394771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000940s ]