SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507202 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507202 [ RunTime:0.002503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212681,46947,745409,767010,255363,129113,725943,57800,249910,576243,1044669,338686,496866,210842,924139,547929,450904,804663,148796,123137,386365,316691,238517,969914,416080,998711,244866,40153,806475,136272,1020660,893392,480056,823027,450684,271948,1039391,194348,214085,319642,677060,22752,842261,100585,970346,423666,138254,1041725,264539,506485,310321,790759,624832,856684,104384,614786,515493,358015,28871,1034118) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]