SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004550s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024843 LIMIT 1 [ RunTime:0.003941s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024843 [ RunTime:0.003281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (960204,280145,734864,82906,898926,567216,576009,551627,866925,780111,1010605,387586,648476,905907,642444,717496,957443,962518,815199,480585,4037,71163,321321,21613,597781,848404,503292,350474,260339,923721,684011,350867,826574,753401,255197,697587,71755,1011868,261829,408190,856157,37531,821144,1005913,360614,284563,407848,99204,761340,157576,144106,885413,942969,801670,215073,530141,524239,776987,537803,816036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]