SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 986180 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 986180 [ RunTime:0.001612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58576,170646,555523,56478,148597,721884,646515,904590,415224,720273,804300,901966,819323,34365,708886,348353,57088,396531,531884,643315,705152,462027,106088,782566,151094,343848,463056,811412,488584,505545,39266,963309,447757,623610,567385,247348,456432,783548,704491,490509,77060,391667,298704,929201,974342,771314,59261,749952,578524,634496,103147,194898,73131,334321,466615,46327,201244,192659,116551,189444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 986180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 986180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]