SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380031 LIMIT 1 [ RunTime:0.000967s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380031 [ RunTime:0.002079s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (926963,728618,948774,64427,806977,516866,47830,1009264,615501,1042762,630728,155273,945643,251291,869789,456164,539618,149298,292638,559302,175446,235883,931550,184509,719481,77458,274321,239098,80584,35193,953843,981443,223815,174144,925658,759573,809285,207016,288110,471181,507750,859444,768013,438836,265749,423432,719053,899898,803216,230658,986135,692174,789663,807106,273314,805597,246940,243182,420576,166735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018719s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003324s ]