SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403480 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403480 [ RunTime:0.002484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791887,526726,522748,73735,261993,183399,35354,220877,600558,434830,312194,533802,410289,717486,236984,1009924,621010,946057,587618,39356,187909,171812,936465,394626,953571,971336,965551,464310,488599,533813,556591,423238,405901,448240,515629,929705,1020330,521212,475438,572383,865348,952862,230677,512024,151270,324006,1035987,65926,990272,557482,717746,965957,828150,395847,496469,195965,703014,887126,800133,306373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]