SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540480 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540480 [ RunTime:0.003007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3077,27776,1031857,707018,218464,215507,83314,398641,86566,457136,1029634,500797,653515,288833,962596,918013,1033561,397070,231771,646296,112491,963305,17019,901662,507226,79714,1019489,13248,271206,1025908,126591,139024,145802,1004078,16484,694254,278174,975198,416615,689076,983195,519905,11002,172768,878770,252037,928805,296321,968935,855836,360377,353798,784413,990412,779651,251854,715180,492666,1038589,975992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]