SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201490 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201490 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408836,1010737,456367,739772,700757,723913,948389,1042069,791127,254048,430328,291443,38370,467889,192614,252726,197392,569639,787401,265585,1033700,738126,13686,361974,335692,952969,734869,946441,714662,781846,897044,796587,673101,183226,523674,101376,828496,111606,234067,42120,455271,676804,982720,560260,35510,988966,112739,316314,380896,427212,567234,947440,291345,752083,681757,532056,84594,383911,732870,692089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]