SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031065 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031065 [ RunTime:0.004567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618843,431174,1000337,995303,812646,829483,916092,706301,851211,568452,1039828,214918,210135,120943,604611,296528,1045355,699258,367848,989981,697455,25384,803771,109080,625713,399927,903469,694673,671014,130611,720194,317076,483254,868228,720746,448103,442540,604946,175315,521951,386252,64470,660939,377188,944801,639887,779411,233710,798192,735979,697168,553209,460583,873981,171899,925725,553842,901939,985355,798553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031065 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031065 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]