SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 964211 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 964211 [ RunTime:0.002045s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291424,30504,389788,18482,160599,661978,412396,346075,745110,366219,398970,892621,463792,18404,948995,685943,1006690,492163,869598,341199,2674,324776,579939,5401,406510,794217,826315,1034259,503520,432771,396010,278073,855760,998447,256214,664199,679263,823108,860046,92821,375356,902849,78358,99569,183676,94085,493436,501740,499908,683682,703192,1001861,1045138,577041,319922,380738,802547,698808,402454,217386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 964211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 964211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]