SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520584 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520584 [ RunTime:0.002563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (594551,261074,342221,78300,399488,513757,1047060,162243,29185,687420,382333,219142,434737,719183,615723,394098,160294,385447,780768,394874,528864,914476,995815,54971,564814,41313,435896,133637,141223,511103,591377,877564,613193,374450,875551,602953,279762,676879,358555,548297,986658,343345,235858,173943,998484,631743,185311,238367,1021042,288389,214963,453849,673149,597745,98312,354535,365383,840666,317707,1008997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]