SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499148 LIMIT 1 [ RunTime:0.003618s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499148 [ RunTime:0.005238s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538608,355739,123512,704984,161808,728345,815383,834625,542593,33406,217412,537408,700496,528792,259679,897639,400990,413544,911291,852935,792782,507214,109998,323911,735967,589018,556013,967291,540889,140037,23363,889468,321748,1008057,372926,548403,902340,339359,127148,866403,130580,184519,794297,471767,324638,611678,971012,373614,596899,129406,748301,231443,1042820,447999,631166,607277,386370,649175,558841,968117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]