SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429423 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429423 [ RunTime:0.002282s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28516,489041,915431,165756,602806,616576,26280,508077,248167,515527,687687,627912,432736,779197,581943,972095,893216,810032,129194,639141,61808,433219,314702,749660,521819,561189,23425,885669,440690,728004,1018549,545875,159163,77460,245776,298479,12881,783102,360187,505500,860812,378190,748771,261464,937187,151945,692943,825356,18224,423666,752448,722273,873355,372395,147149,352235,30324,187485,5137,87894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001070s ]