SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020857 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020857 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577692,514793,510558,558818,803486,870607,117149,988646,844069,1000446,219651,21648,494370,166657,128654,701267,972230,400301,334245,661020,456350,317253,967101,971781,413310,280874,738465,620134,265372,773154,95542,632614,893,904056,2352,567395,19961,581686,261136,287414,37387,945417,218773,87129,72522,848912,996366,668287,105633,892771,683046,979918,10883,766936,385563,549636,788090,914932,458312,452134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001743s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]