SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343384 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343384 [ RunTime:0.002262s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271648,191858,343795,722196,782649,49732,439448,697278,503286,525384,922489,102868,469528,95736,127430,956161,875122,689988,158457,240984,384225,955066,557645,412198,911040,1143,359797,912137,614654,581230,492503,161897,392666,360410,760151,309645,470617,839782,909864,500669,23325,779378,531724,643973,525269,767405,113270,634531,739573,823710,233873,365205,988408,357552,1028054,992926,356780,422015,134956,319945) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343384 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343384 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]