SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351423 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351423 [ RunTime:0.002618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675709,525210,333890,493577,1032743,279413,25272,841576,466153,727744,109238,886195,806622,377192,490781,32354,945207,1010955,127760,116610,604703,835845,41253,429728,1033249,1014309,188603,1996,369254,466227,677899,832503,460169,903121,215733,634038,70752,106197,42139,930073,424281,945547,606566,4090,925183,701556,729822,80787,1043526,882942,1019281,558430,843668,1016979,258181,298660,4374,484677,472466,1011765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000713s ]