SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 37403 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 37403 [ RunTime:0.003320s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150398,298122,924356,88152,934867,203822,1018476,328655,438617,918099,135950,57813,758146,872311,374029,463170,543919,428369,40615,574996,609800,338749,526058,361970,790193,786267,387870,464191,325744,998934,964792,1021377,888642,1030173,329176,416211,336444,144253,15466,889754,609707,577186,928434,1027267,25653,756112,162817,802563,99216,143756,576577,443786,137131,236358,66434,120021,528422,649725,164922,837331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 37403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 37403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]