SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286891 LIMIT 1 [ RunTime:0.002423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286891 [ RunTime:0.003350s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529862,656203,818233,613800,808612,982708,771970,337760,819559,912683,723157,631887,450628,884441,611636,565246,655479,166610,537576,300972,725253,726517,111915,774537,697831,159634,665087,475490,790540,899592,1004135,613361,541071,389442,223103,482167,172050,556812,689253,768337,665474,225408,281353,307198,541607,470404,741079,677,719810,922694,75009,549887,848481,137911,509121,920072,461771,887575,837624,484303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002847s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]