SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452009 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452009 [ RunTime:0.002825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356206,283637,132099,146505,714886,670647,654658,4651,959673,949590,104864,461580,152264,551768,828856,140512,298671,729022,707068,340799,387673,509990,586107,813400,267289,1034639,401641,373651,358310,13043,961391,613981,735519,519329,180878,1028557,380748,234061,96771,923406,754217,628803,6565,695762,167271,233978,494397,656517,613943,259740,395800,956476,951863,393430,697070,8223,678849,269397,67158,836568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]