SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001569s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555540 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555540 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768223,662969,315691,568742,217143,377219,477864,22622,455119,565750,41310,984575,576277,1003334,100444,62,694466,487695,830765,960854,250362,51582,958242,325591,254923,984188,383055,512273,604982,636498,914320,1027563,344259,666788,955254,66416,86955,563037,659350,431176,796045,585783,1000870,697496,852441,101192,84525,515205,1033031,577177,588761,283978,343225,270686,87972,653777,248218,385986,108584,864256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]