SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001598s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150413 LIMIT 1 [ RunTime:0.000509s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150413 [ RunTime:0.002991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588843,387611,877853,639402,241718,210736,564826,154190,299153,484060,682722,680038,437836,596268,241961,895171,461162,600131,361608,540236,176222,597769,328186,395778,506818,794574,1047344,829823,60360,248308,342887,827910,545978,718313,563146,306990,256143,719839,499199,219267,125766,777649,91430,173726,712933,900912,585635,888283,775173,650593,972264,474937,589205,322833,718359,494829,732269,302863,709880,381039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000854s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004065s ]