SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000185 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000185 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140171,4480,425962,983356,283643,216524,396816,700122,526378,865464,400461,740300,962319,441157,56983,348947,142391,611784,362513,920063,344309,575311,698912,716053,395223,760485,552588,242648,523130,425978,218458,635311,854774,919860,302240,123877,462167,783194,994680,624051,769724,168192,611295,389073,384417,568559,969784,988696,927897,1012195,179894,535988,155193,593374,399845,770938,80651,555052,192806,581847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007622s ]