SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004094 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004094 [ RunTime:0.002491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333953,15726,985069,834458,890512,57931,185214,884085,191162,718233,596944,941034,10419,641509,607490,429256,60326,97051,187624,459528,1046768,289156,904864,3101,749514,64378,511980,377091,1014746,612206,957070,137987,437665,541799,670500,585015,973669,57125,890306,663993,411811,943367,288302,338332,365644,788556,898129,1001951,521080,69595,545112,615277,119144,1037053,777977,377737,598663,561274,962540,744002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001275s ]