SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290211 LIMIT 1 [ RunTime:0.002592s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290211 [ RunTime:0.004729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279999,754032,651488,609546,57025,563977,587301,958428,854122,810809,836644,809004,871287,103,550781,744874,599743,326997,328890,551253,177700,7789,541471,79272,277734,1046826,523108,121374,45436,943151,992823,553618,78611,789736,192454,777652,788494,828117,975652,26127,312915,526898,396791,767388,722330,575700,18054,730581,413084,318945,115425,565248,46056,385296,427491,204507,37166,829669,876939,831511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]