SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003639 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003639 [ RunTime:0.003958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912575,179661,640459,131839,441039,146104,20516,78641,38132,102096,955454,855957,502598,297741,771502,423361,526901,641134,344918,259110,111144,114174,167871,203889,245922,961471,745540,603315,626230,710295,246710,413419,400920,122788,664726,939374,563110,55480,212395,883603,256554,819122,481557,790412,673885,494177,1014732,33081,7129,411183,415427,317778,125323,988206,344104,430397,152178,806849,71537,395761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003639 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003639 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]