SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104723 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104723 [ RunTime:0.003318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643194,552822,764913,850601,697420,779644,155972,1010213,308774,72675,925028,357736,475434,652074,974342,91692,161476,238916,969525,135529,409841,810541,95147,757353,752907,91910,736554,854561,816214,374131,339376,988385,154516,330677,241228,1045046,527674,699951,170220,618960,930538,832749,110860,798380,133377,1016428,868891,835970,415944,884612,581595,136705,548792,382183,912670,214195,145246,958912,213766,270071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]