SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556928 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556928 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829387,741146,171890,720097,1026112,337236,449555,229629,299026,557122,808874,544261,787558,993638,660048,123528,253957,874995,627110,456162,119328,666866,8645,680814,44379,212386,360685,716683,695956,452649,130304,818618,590780,550640,947153,502118,233952,891791,1022684,322704,718969,976172,175215,656475,248822,204384,397747,685569,1025720,504806,422844,738220,465610,121705,113725,833387,968958,816165,603344,316096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]