SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440525 LIMIT 1 [ RunTime:0.003324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440525 [ RunTime:0.002534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499681,117645,164808,215423,283789,609614,911234,361279,427464,824802,614749,1016768,690460,579917,289675,1005420,160504,803445,315539,374293,110248,526407,255193,447289,90715,564729,790692,374253,783776,384207,407579,940952,974464,521105,1046245,873798,621834,469261,887271,1036752,149599,460046,311993,117960,314590,633216,867454,814892,235073,98794,524569,499937,319753,673836,517335,46539,56025,517233,861428,258312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440525 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440525 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]