SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300929 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300929 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024659,57437,414411,484683,477237,692164,149618,328261,299308,268184,40434,662450,430145,423253,841933,236057,1045724,37073,838200,859909,786294,472570,372287,180152,26747,631832,48518,41002,1017843,441595,265547,870654,985108,649520,929609,112639,1046222,530243,793009,557785,712783,695748,148213,1014792,422778,164508,956900,219436,138516,38074,586349,702419,222866,911966,60268,562285,14161,86338,635008,989594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300929 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300929 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]