SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007480 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007480 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024396,684216,68946,975866,540900,965887,352598,1027257,259701,668138,320841,112481,959007,321867,424496,39732,39748,553462,337458,30197,801180,143770,899804,121193,743146,311950,958987,112948,526516,457699,1022808,294124,326634,674175,138045,766304,320926,215378,634894,776525,760964,312186,103351,830937,891946,807828,467706,499810,637312,777890,1042728,994128,778962,616031,365156,1034607,723509,367014,614196,230113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]